Array Function

Assigns a list of values to consecutive elements of an array.

Syntax

result = Array( ElementList )


Parameters

ElementList

Type

A comma delimited list of values that are used to populate result. The data type of the items in ElementList should agree with the data type of the array result.



Notes

The Array function provides the same functionality as separate assignment statements for each element of an array, beginning with element zero and proceeding consecutively. If there are more elements in the array than items in the list of elements, then the "extra" elements are not disturbed.


Example

The following statement creates and populates the first three elements of the array aNames.

Dim aNames() as String
//using the Array function
aNames=Array("Fred","Ginger","Stanley")

See Also

Dim statement; Join, Split, Ubound functions; Append, IndexOf, Insert, Pop, Redim, Remove, Shuffle, Sort, Sortwith methods; ParamArray keyword.